Introduction
The reconciliation feature can be used in countries where cheques are booked directly to a cash instrument. You can automatically reconcile bank transactions/entries with bank statements at Cash flow/Entries/Bank reconciliation/Automatic. Alternatively, go to Cash flow/Entries/Import, and then click the Reconcile button.
Note: This feature is not relevant to Dutch users.
Description
You can filter the reconciliation statement that you want to display. To search for the statement, you can define one or more of the following criteria and click Refresh. The statement that matches the search criteria you have entered is then displayed.
Show
Select Unreconcile to view unreconciled entries or Reconcile to view reconciled entries.
Own bank account
Type or select a bank account number to view the reconciliation statements.
Statement number
Type or select a statement number to view the reconciliation statements.
Show
Select the type of transactions you want displayed. You can choose from Cash in, Cash out, or All.
Range
Select Date to enable the Date field or Period to enable the Period field.
Date
Type or select the Date range to view the reconciliation statements within this range or select All for all dates. This is enabled only if Date is selected at Range.
Financial year
Select the Financial year and type the Period range to view the reconciliation statements within this range. This is enabled only if Period is selected at Range.
Filter section
Filter button
Click this to display the filter criteria. When you click Filter again, all criteria will be hidden.
Clear button
Click this to clear the defined criteria.
Filter
Select the required option to filter the reconciliation statements that Starts with or Contains a certain letter or word.
Bank statement section
Payment reference
Type a payment reference to view bank statements with this payment reference.
Amount
Type the amount range to view bank statements within this range or select All for all amounts.
Cash / bank section
Our ref.
Type an our ref. code to view bank/cash entries with this code.
Payment reference
Type a payment reference to view bank/cash entries with this reference number.
Entry number
Type an entry number to view bank/cash entries with this entry number.
Run number
Type a run number to view bank/cash entries with this run number.
Description
Type a description to view bank/cash entries with this description.
Instrument no.
Type an instrument number to view bank/cash entries with this instrument number.
Deposit number
Type a deposit number to view bank/cash entries with this deposit number.
Amount
Type an amount range to view bank/cash entries within this range or select All for all amounts.
Results section
The Results section displays the bank import statement and the bank/cash entry lines.
Buttons
Book costs
Click this to go to the Book cost entry screen. If both the bank import statement and the bank/cash entry lines are selected, you can book the difference between the bank import statement and the bank/cash entries. If only the bank import statement is selected, the total amount of the selected bank statement will be displayed. This button is enabled only when bank statement entries are selected and no transactions have been booked or recorded in the database. For more information, see Booking of costs.
Print
Click this to print the reconciliation statement.
Refresh
Click this to update the data according to the defined criteria.
Search
Click this to open a file screen. You can then select the bank reconciliation statement file provided by the bank. The Bank name screen will then be displayed where you have to select the correct bank name. If a wrong selection is made, the message “Invalid bank account: No Transactions” will be displayed. If the right selection is made, the message “Import file: Completed” will be displayed. Click OK to return to the Bank reconciliation screen.
Auto reconcile
Click this so that the system can automatically match and reconcile the entries. Automatic reconciliation is based on Creditor number, Debtor number, Amount, Offset reference, Own bank account, Statement number, Statement date, Payment reference, Transaction date, and Value date.
Details
Click this to view the details of the cash flow entry. This button is enabled only if the cash flow entry under the Cash / bank section is selected. If the financial period of the selected entry is closed, fields such as Amount, Date, Bank reference, Statement number, Statement date, Deposit number, Payment method, Payment type, and Allocation in the cash flow entry cannot be edited.
New
Click this to create a new cash in or cash out entry when a bank statement line is selected but no bank transactions exist in the database. For more information, see Entering payment and receipt.
Unreconciled
Click this to reset the statement number and statement date to unreconcile the reconciled entries. This button is enabled only for reconciled entries.
Reconcile
Click this to manually match a selected bank entry with a bank statement. These will then be marked as reconciled entries.
Close
Click this to exit.
Related documents